<?php

use Phinx\Migration\AbstractMigration;

class V31010 extends AbstractMigration
{
    public function up()
    {
        $this->execute("ALTER TABLE `absence_types` COMMENT = 'This table contains absence types used in absence records'");
        $this->execute("ALTER TABLE `academic_period_levels` COMMENT = 'This table contains the levels of academic periods eg. Yearly, Semester, Term'");
        $this->execute("ALTER TABLE `academic_periods` COMMENT = 'This table contains the list of academic school periods'");
        $this->execute("ALTER TABLE `alert_logs` COMMENT = 'This table contains the list of alert logs for a given feature'");
        $this->execute("ALTER TABLE `alert_rules` COMMENT = 'This table contains the rules to trigger a specific alert'");
        $this->execute("ALTER TABLE `alerts` COMMENT = 'This table contains the list of available alerts supported by the system'");
        $this->execute("ALTER TABLE `alerts_roles` COMMENT = 'This table contains the roles of the users who will receive the alerts'");
        $this->execute("ALTER TABLE `api_authorizations` COMMENT = 'This table contains the security tokens that allow public to access OpenEMIS Core APIs'");
        $this->execute("ALTER TABLE `area_administrative_levels` COMMENT = 'This table contains the administrative area levels of the country'");
        $this->execute("ALTER TABLE `area_administratives` COMMENT = 'This table contains the administrative areas of the country'");
        $this->execute("ALTER TABLE `area_levels` COMMENT = 'This table contains the educational area levels of the country'");
        $this->execute("ALTER TABLE `areas` COMMENT = 'This table contains the educational areas of the country'");
        $this->execute("ALTER TABLE `assessment_grading_options` COMMENT = 'This table contains all options linked to a specific grading type'");
        $this->execute("ALTER TABLE `assessment_grading_types` COMMENT = 'This table contains the list of grading types that can be used for an assessable subject'");
        $this->execute("ALTER TABLE `assessment_item_results` COMMENT = 'This table contains all the assessment results for an individual student in an institution'");
        $this->execute("ALTER TABLE `assessment_items` COMMENT = 'This table contains the list of assessment items for a specific assessment'");
        $this->execute("ALTER TABLE `assessment_items_grading_types` COMMENT = 'This table contains the list of grading types that can be used for an assessment item'");
        $this->execute("ALTER TABLE `assessment_periods` COMMENT = 'This table contains the list of periods for a specific assessment'");
        $this->execute("ALTER TABLE `assessments` COMMENT = 'This table contains the assessment template for a specific grade'");
        $this->execute("ALTER TABLE `bank_branches` COMMENT = 'This table contains the bank branches information used by institutions and individuals'");
        $this->execute("ALTER TABLE `banks` COMMENT = 'This table contains the bank information used by institutions and individuals'");
        $this->execute("ALTER TABLE `behaviour_classifications` COMMENT = 'This table contains user-defined values to classify a behaviour category'");
        $this->execute("ALTER TABLE `building_custom_field_values` COMMENT = 'This table contains the value of user created custom fields for buildings'");
        $this->execute("ALTER TABLE `building_types` COMMENT = 'This is a field option table containing different types of buildings used in institution_buildings'");
        $this->execute("ALTER TABLE `comment_types` COMMENT = 'This is a field option table containing the list of user-defined types of comments'");
        $this->execute("ALTER TABLE `competencies` COMMENT = 'This is a field option table containing the list of user-defined competencies used in staff appraisal'");
        $this->execute("ALTER TABLE `competency_criterias` COMMENT = 'This table contains the list of competency criterias for a given competency item'");
        $this->execute("ALTER TABLE `competency_grading_options` COMMENT = 'This table contains all options linked to a specific grading type for competency'");
        $this->execute("ALTER TABLE `competency_grading_types` COMMENT = 'This table contains the list of grading types that can be used for an assessable competency'");
        $this->execute("ALTER TABLE `competency_items` COMMENT = 'This table contains the list of competency items for a given competency template'");
        $this->execute("ALTER TABLE `competency_items_periods` COMMENT = 'This table contains the list of competency items for a specific competency period'");
        $this->execute("ALTER TABLE `competency_periods` COMMENT = 'This table contains the list of periods for a specific competency'");
        $this->execute("ALTER TABLE `competency_sets` COMMENT = 'This is a field option table containing the list of user-defined sets to group competencies'");
        $this->execute("ALTER TABLE `competency_sets_competencies` COMMENT = 'This is a field option table containing the list of competencies that are linked to competency sets'");
        $this->execute("ALTER TABLE `competency_templates` COMMENT = 'This table contains the competency template for a specific grade'");
        $this->execute("ALTER TABLE `config_attachments` COMMENT = 'This table contains images or logo that are used on the in the system'");
        $this->execute("ALTER TABLE `config_item_options` COMMENT = 'This table contains the list of configuration options for specific configuration'");
        $this->execute("ALTER TABLE `config_items` COMMENT = 'This table contains the list of configurations used by the system'");
        $this->execute("ALTER TABLE `config_product_lists` COMMENT = 'This table contains the list of external products that can be accessilble via OpenEMIS'");
        $this->execute("ALTER TABLE `contact_options` COMMENT = 'This table contains the options of specific type of contacts'");
        $this->execute("ALTER TABLE `contact_types` COMMENT = 'This table contains the different types of contacts'");
        $this->execute("ALTER TABLE `countries` COMMENT = 'This table contains the list of countries of the world'");
        $this->execute("ALTER TABLE `custom_field_options` COMMENT = 'This table contains the list of options used by custom field of type Dropdown'");
        $this->execute("ALTER TABLE `custom_field_types` COMMENT = 'This table contains the list of available custom field types that are used in the system'");
        $this->execute("ALTER TABLE `custom_field_values` COMMENT = 'This table contains the value of user created custom fields for testing purposes'");
        $this->execute("ALTER TABLE `custom_fields` COMMENT = 'This table contains the list of custom fields for testing purposes'");
        $this->execute("ALTER TABLE `custom_forms` COMMENT = 'This table contains the labels to group the custom fields'");
        $this->execute("ALTER TABLE `custom_forms_fields` COMMENT = 'This table indicates which custom fields is grouped under which form'");
        $this->execute("ALTER TABLE `custom_forms_filters` COMMENT = 'This table contains groups of custom fields for testing purposes'");
        $this->execute("ALTER TABLE `custom_modules` COMMENT = 'This table contains the list of modules that allows custom fields'");
        $this->execute("ALTER TABLE `custom_records` COMMENT = 'This table contains testing records linked to custom fields'");
        $this->execute("ALTER TABLE `custom_table_cells` COMMENT = 'This table contains the values of a table-type question in a form'");
        $this->execute("ALTER TABLE `custom_table_columns` COMMENT = 'This table contains the column name of a table-type question'");
        $this->execute("ALTER TABLE `custom_table_rows` COMMENT = 'This table contains the row name of a table-type question'");
        $this->execute("ALTER TABLE `deleted_records` COMMENT = 'This table contains data of previously deleted records'");
        $this->execute("ALTER TABLE `education_certifications` COMMENT = 'This table contains all information related to academic certifications'");
        $this->execute("ALTER TABLE `education_cycles` COMMENT = 'This table contains the list of education cycles'");
        $this->execute("ALTER TABLE `education_field_of_studies` COMMENT = 'This table contains the list of field of studies'");
        $this->execute("ALTER TABLE `education_grades` COMMENT = 'This table contains the list of education grades linked to specific education programmes'");
        $this->execute("ALTER TABLE `education_grades_subjects` COMMENT = 'This table contains the list of subjects linked to specific education grade'");
        $this->execute("ALTER TABLE `education_level_isced` COMMENT = 'This table contains the standard education levels used in ISCED'");
        $this->execute("ALTER TABLE `education_levels` COMMENT = 'This table contains the list of education levels'");
        $this->execute("ALTER TABLE `education_programme_orientations` COMMENT = 'This table contains the programme orientation such as General or Vocational'");
        $this->execute("ALTER TABLE `education_programmes` COMMENT = 'This table contains the list of education programmes'");
        $this->execute("ALTER TABLE `education_programmes_next_programmes` COMMENT = 'This table contains the next programme linked to existing programmes'");
        $this->execute("ALTER TABLE `education_subjects` COMMENT = 'This table contains the educational subjects'");
        $this->execute("ALTER TABLE `education_systems` COMMENT = 'This table contains the list of education systems'");
        $this->execute("ALTER TABLE `employment_types` COMMENT = 'This is a field option table used by staff_employments'");
        $this->execute("ALTER TABLE `examination_centre_rooms` COMMENT = 'This table contains the rooms for a particular examination centre'");
        $this->execute("ALTER TABLE `examination_centre_rooms_examinations` COMMENT = 'This table contains the examination centres for a particular examination'");
        $this->execute("ALTER TABLE `examination_centre_rooms_examinations_invigilators` COMMENT = 'This table contains the invigilators assigned to a room for a particular examination centre'");
        $this->execute("ALTER TABLE `examination_centre_rooms_examinations_students` COMMENT = 'This table contains the students allocated to a room for a particular examination center'");
        $this->execute("ALTER TABLE `examination_centre_special_needs` COMMENT = 'This table contains the special needs for a particular examination centre'");
        $this->execute("ALTER TABLE `examination_centres` COMMENT = 'This table contains the examination centres for an academic period'");
        $this->execute("ALTER TABLE `examination_centres_examinations` COMMENT = 'This table contains the examination centres for a particular examination'");
        $this->execute("ALTER TABLE `examination_centres_examinations_institutions` COMMENT = 'This table contains the list of institutions linked to a particular examination centre'");
        $this->execute("ALTER TABLE `examination_centres_examinations_invigilators` COMMENT = 'This table contains the invigilators for a particular examination centre'");
        $this->execute("ALTER TABLE `examination_centres_examinations_students` COMMENT = 'This table contains the students registered to an examination center for a particular examination'");
        $this->execute("ALTER TABLE `examination_centres_examinations_subjects` COMMENT = 'This table contains the examination centres for a particular examination subject'");
        $this->execute("ALTER TABLE `examination_centres_examinations_subjects_students` COMMENT = 'This table contains the students registered to an examination center for a particular examination subject'");
        $this->execute("ALTER TABLE `examination_grading_options` COMMENT = 'This table contains all options linked to a specific grading type'");
        $this->execute("ALTER TABLE `examination_grading_types` COMMENT = 'This table contains the list of grading types that can be used for an examination subject'");
        $this->execute("ALTER TABLE `examination_item_results` COMMENT = 'This table contains all the examination results for an individual student in a particular examination'");
        $this->execute("ALTER TABLE `examination_items` COMMENT = 'This table contains the examination subjects for a particular examination'");
        $this->execute("ALTER TABLE `examinations` COMMENT = 'This table contains the examination for a specific grade'");
        $this->execute("ALTER TABLE `external_data_source_attributes` COMMENT = 'This table contains the list of attributes used for configuring external data source'");
        $this->execute("ALTER TABLE `extracurricular_types` COMMENT = 'This is a field option table used by student_extracurriculars/staff_extracurriculars'");
        $this->execute("ALTER TABLE `fee_types` COMMENT = 'This table contains the list of items chargable to individual students'");
        $this->execute("ALTER TABLE `floor_custom_field_values` COMMENT = 'This table contains the value of user created custom fields for floors'");
        $this->execute("ALTER TABLE `floor_types` COMMENT = 'This is a field option table containing different types of floors used in institution_floors'");
        $this->execute("ALTER TABLE `genders` COMMENT = 'This table contain the two types of gender (Male / Female) used by security_users'");
        $this->execute("ALTER TABLE `guardian_relations` COMMENT = 'This is a field option table containing different type of relationship of a guardian and a student'");
        $this->execute("ALTER TABLE `health_allergy_types` COMMENT = 'This is a field option table used by user_health_allergies'");
        $this->execute("ALTER TABLE `health_conditions` COMMENT = 'This is a field option table containing the list of user-defined conditions used by user_health_families and user_health_histories'");
        $this->execute("ALTER TABLE `health_consultation_types` COMMENT = 'This is a field option table containing the list of user-defined consultation_types used by user_health_consultations'");
        $this->execute("ALTER TABLE `health_immunization_types` COMMENT = 'This is a field option table containing the list of user-defined immunization_types used by user_health_immunizations'");
        $this->execute("ALTER TABLE `health_relationships` COMMENT = 'This is a field option table containing the list of user-defined relationships used by user_health_families'");
        $this->execute("ALTER TABLE `health_test_types` COMMENT = 'This is a field option table containing the list of user-defined test_types used by user_health_tests'");
        $this->execute("ALTER TABLE `identity_types` COMMENT = 'This is a field option table containing the different types of identity used by user_identities'");
        $this->execute("ALTER TABLE `import_mapping` COMMENT = 'This table contains the mapping of the fields used by all Import features'");
        $this->execute("ALTER TABLE `indexes` COMMENT = 'This table contains user created indexes for the assessing students in institutions'");
        $this->execute("ALTER TABLE `indexes_criterias` COMMENT = 'This table contains the list of criteria of an index'");
        $this->execute("ALTER TABLE `infrastructure_conditions` COMMENT = 'This is a field option table containing the different types of conditions used by institution_infrastructures'");
        $this->execute("ALTER TABLE `infrastructure_custom_field_options` COMMENT = 'This table contains the list of options used by custom field of type Dropdown'");
        $this->execute("ALTER TABLE `infrastructure_custom_fields` COMMENT = 'This table contains the list of custom fields used by infrastructure'");
        $this->execute("ALTER TABLE `infrastructure_custom_forms` COMMENT = 'This table contains the labels to group the custom fields'");
        $this->execute("ALTER TABLE `infrastructure_custom_forms_fields` COMMENT = 'This table indicates which custom fields is grouped under which form'");
        $this->execute("ALTER TABLE `infrastructure_custom_forms_filters` COMMENT = 'This table contains groups of custom fields by infrastructure types'");
        $this->execute("ALTER TABLE `infrastructure_levels` COMMENT = 'This is a field option table containing the different types of levels used by institution_infrastructures'");
        $this->execute("ALTER TABLE `infrastructure_ownerships` COMMENT = 'This is a field option table containing the different types of ownerships used by institution_infrastructures'");
        $this->execute("ALTER TABLE `infrastructure_statuses` COMMENT = 'This table contains a fixed list of statuses for infrastructure'");
        $this->execute("ALTER TABLE `institution_activities` COMMENT = 'This table contains all modification of information related to every institution'");
        $this->execute("ALTER TABLE `institution_attachments` COMMENT = 'This table contains any file type information related to every institution'");
        $this->execute("ALTER TABLE `institution_bank_accounts` COMMENT = 'This table contains the bank accounts used by institutions'");
        $this->execute("ALTER TABLE `institution_buildings` COMMENT = 'This table contains all building information of all institutions'");
        $this->execute("ALTER TABLE `institution_case_records` COMMENT = 'This table contains the list of records associates with cases'");
        $this->execute("ALTER TABLE `institution_cases` COMMENT = 'This table contains all the cases in a particular institution'");
        $this->execute("ALTER TABLE `institution_class_grades` COMMENT = 'This table contains multi-grade classes information'");
        $this->execute("ALTER TABLE `institution_class_students` COMMENT = 'This table contains information of students in classes'");
        $this->execute("ALTER TABLE `institution_class_subjects` COMMENT = 'This table contains information about the subjects of any class'");
        $this->execute("ALTER TABLE `institution_classes` COMMENT = 'This table contains the list of classes by grade and academic period in every institution'");
        $this->execute("ALTER TABLE `institution_custom_field_options` COMMENT = 'This table contains the list of options used by custom field of type Dropdown'");
        $this->execute("ALTER TABLE `institution_custom_field_values` COMMENT = 'This table contains the value of user created custom fields for institutions'");
        $this->execute("ALTER TABLE `institution_custom_fields` COMMENT = 'This table contains the list of custom fields used by institution'");
        $this->execute("ALTER TABLE `institution_custom_forms` COMMENT = 'This table contains the labels to group the custom fields'");
        $this->execute("ALTER TABLE `institution_custom_forms_fields` COMMENT = 'This table indicates which custom fields is grouped under which form'");
        $this->execute("ALTER TABLE `institution_custom_forms_filters` COMMENT = 'This table contains groups of custom fields by institution types'");
        $this->execute("ALTER TABLE `institution_custom_table_cells` COMMENT = 'This table contains the values of a table-type question in a form'");
        $this->execute("ALTER TABLE `institution_custom_table_columns` COMMENT = 'This table contains the column name of a table-type question'");
        $this->execute("ALTER TABLE `institution_custom_table_rows` COMMENT = 'This table contains the row name of a table-type question'");
        $this->execute("ALTER TABLE `institution_fee_types` COMMENT = 'This table contains all the chargable items of a specific grade and year for all institutions'");
        $this->execute("ALTER TABLE `institution_fees` COMMENT = 'This table contains the total chargable amount by grade and year for all institutions'");
        $this->execute("ALTER TABLE `institution_floors` COMMENT = 'This table contains all floor information of all institutions'");
        $this->execute("ALTER TABLE `institution_genders` COMMENT = 'This table contains the types of institution gender used by institution'");
        $this->execute("ALTER TABLE `institution_grades` COMMENT = 'This table contains information about education grades offered by institutions'");
        $this->execute("ALTER TABLE `institution_indexes` COMMENT = 'This table contains the status of indexes and the processing date in all institutions'");
        $this->execute("ALTER TABLE `institution_lands` COMMENT = 'This table contains all land information of all institutions'");
        $this->execute("ALTER TABLE `institution_localities` COMMENT = 'This is a field option table containing the list of user-defined locality used by institutions'");
        $this->execute("ALTER TABLE `institution_network_connectivities` COMMENT = 'This is a field option table containing the list of user-defined network_types used by institutions'");
        $this->execute("ALTER TABLE `institution_ownerships` COMMENT = 'This is a field option table containing the list of user-defined ownerships used by institutions'");
        $this->execute("ALTER TABLE `institution_positions` COMMENT = 'This table contains the list of positions offered by the institutions'");
        $this->execute("ALTER TABLE `institution_providers` COMMENT = 'This is a field option table containing the list of user-defined providers used by institutions'");
        $this->execute("ALTER TABLE `institution_quality_rubric_answers` COMMENT = 'This table contains user entered answers for a rubric template'");
        $this->execute("ALTER TABLE `institution_quality_rubrics` COMMENT = 'This is a workflow table to group rubric answers'");
        $this->execute("ALTER TABLE `institution_quality_visits` COMMENT = 'This table contains information related to visits to a school by staff members'");
        $this->execute("ALTER TABLE `institution_repeater_survey_answers` COMMENT = 'This table contains repeater type answers of a survey'");
        $this->execute("ALTER TABLE `institution_repeater_survey_table_cells` COMMENT = 'This table contains repeater type table values of a survey'");
        $this->execute("ALTER TABLE `institution_repeater_surveys` COMMENT = 'This table contains repeater type questions in a survey'");
        $this->execute("ALTER TABLE `institution_rooms` COMMENT = 'This table contains all room information of all institutions'");
        $this->execute("ALTER TABLE `institution_sectors` COMMENT = 'This is a field option table containing the list of user-defined sectors used by institutions'");
        $this->execute("ALTER TABLE `institution_shifts` COMMENT = 'This table contains all shifts offered by every institution'");
        $this->execute("ALTER TABLE `institution_staff` COMMENT = 'This table contains information of all staff in every institution'");
        $this->execute("ALTER TABLE `institution_staff_absences` COMMENT = 'This table contains absence records of staff'");
        $this->execute("ALTER TABLE `institution_staff_assignments` COMMENT = 'This table contains staff tranfer requests'");
        $this->execute("ALTER TABLE `institution_staff_leave` COMMENT = 'This table contains all leave applications and their statuses of staff'");
        $this->execute("ALTER TABLE `institution_staff_position_profiles` COMMENT = 'This table contains change requests submitted for Staff profiles'");
        $this->execute("ALTER TABLE `institution_statuses` COMMENT = 'This is a field option table containing the list of user-defined statuses used by institutions'");
        $this->execute("ALTER TABLE `institution_student_absences` COMMENT = 'This table contains absence records of students'");
        $this->execute("ALTER TABLE `institution_student_admission` COMMENT = 'This table contains student admission records'");
        $this->execute("ALTER TABLE `institution_student_indexes` COMMENT = 'This table contains the index of all students based on the configured criteria'");
        $this->execute("ALTER TABLE `institution_student_survey_answers` COMMENT = 'This table contains the student list answers of a survey'");
        $this->execute("ALTER TABLE `institution_student_survey_table_cells` COMMENT = 'This table contains the information of the survey question type - table'");
        $this->execute("ALTER TABLE `institution_student_surveys` COMMENT = 'This table contains the student list type questions in a survey'");
        $this->execute("ALTER TABLE `institution_student_withdraw` COMMENT = 'This table contains all student dropout requests'");
        $this->execute("ALTER TABLE `institution_students` COMMENT = 'This table contains information of all students in every institution'");
        $this->execute("ALTER TABLE `institution_subject_staff` COMMENT = 'This table contains the list of subjects taught by which teacher'");
        $this->execute("ALTER TABLE `institution_subject_students` COMMENT = 'This table contains the list of students attending the subjects'");
        $this->execute("ALTER TABLE `institution_subjects` COMMENT = 'This table contains the list of subjects taught by the institution'");
        $this->execute("ALTER TABLE `institution_subjects_rooms` COMMENT = 'This table contains the room information of the subject that was taught in'");
        $this->execute("ALTER TABLE `institution_survey_answers` COMMENT = 'This table contains the answers to each question in a form'");
        $this->execute("ALTER TABLE `institution_survey_table_cells` COMMENT = 'This table contains the values of a table-type question in a form'");
        $this->execute("ALTER TABLE `institution_surveys` COMMENT = 'This table contains the list of forms that all institutions need to complete and their current progress'");
        $this->execute("ALTER TABLE `institution_textbooks` COMMENT = 'This table contains all textbooks used by institutions'");
        $this->execute("ALTER TABLE `institution_types` COMMENT = 'This is a field option table containing the list of user-defined types used by institutions'");
        $this->execute("ALTER TABLE `institution_visit_requests` COMMENT = 'This table contains all visit requested by the institutions'");
        $this->execute("ALTER TABLE `institutions` COMMENT = 'This table contains information of every institution'");
        $this->execute("ALTER TABLE `labels` COMMENT = 'This table contains all field labels used in the system'");
        $this->execute("ALTER TABLE `land_custom_field_values` COMMENT = 'This table contains the value of user created custom fields for lands'");
        $this->execute("ALTER TABLE `land_types` COMMENT = 'This is a field option table containing different types of land used in institution_lands'");
        $this->execute("ALTER TABLE `languages` COMMENT = 'This table contains the list of possible languages'");
        $this->execute("ALTER TABLE `license_classifications` COMMENT = 'This is a field option table containing the list of user-defined classification of licences used by staff_licenses'");
        $this->execute("ALTER TABLE `license_types` COMMENT = 'This is a field option table containing the list of user-defined type of licences used by staff_licenses'");
        $this->execute("ALTER TABLE `nationalities` COMMENT = 'This is a field option table containing the list of user-defined nationalities used by user_nationalities'");
        $this->execute("ALTER TABLE `notices` COMMENT = 'This table contains all notices that are displayed on the dashboard'");
        $this->execute("ALTER TABLE `qualification_levels` COMMENT = 'Not in used atm'");
        $this->execute("ALTER TABLE `qualification_titles` COMMENT = 'This table contains the titles of the qualifications'");
        $this->execute("ALTER TABLE `quality_visit_types` COMMENT = 'This is a field option table containing the list of user-defined types of visits used by institution visits'");
        $this->execute("ALTER TABLE `report_progress` COMMENT = 'This table contains the report generation progress'");
        $this->execute("ALTER TABLE `room_custom_field_values` COMMENT = 'This table contains the value of user created custom fields for rooms'");
        $this->execute("ALTER TABLE `room_types` COMMENT = 'This is a field option table containing different types of rooms used in institution_rooms'");
        $this->execute("ALTER TABLE `rubric_criteria_options` COMMENT = 'This table contains the options of a rubric criteria'");
        $this->execute("ALTER TABLE `rubric_criterias` COMMENT = 'This table contains the criterias used in a rubric template section'");
        $this->execute("ALTER TABLE `rubric_sections` COMMENT = 'This table contains the sections used in a rubric template'");
        $this->execute("ALTER TABLE `rubric_status_periods` COMMENT = 'This table indicates the rubrics is done for which academic period'");
        $this->execute("ALTER TABLE `rubric_status_programmes` COMMENT = 'This table indicates the education programme offered by the school that can access the rubrics'");
        $this->execute("ALTER TABLE `rubric_status_roles` COMMENT = 'This table indicates the roles that can access the rubrics'");
        $this->execute("ALTER TABLE `rubric_statuses` COMMENT = 'This table indicates the date period that allows user for data entry'");
        $this->execute("ALTER TABLE `rubric_template_options` COMMENT = 'This table contains the answer options used by rubric template'");
        $this->execute("ALTER TABLE `rubric_templates` COMMENT = 'This table contains all rubric templates'");
        $this->execute("ALTER TABLE `salary_addition_types` COMMENT = 'This is a field option table containing different types of salary addition used in staff_salary_additions'");
        $this->execute("ALTER TABLE `salary_deduction_types` COMMENT = 'This is a field option table containing different types of salary deduction used in staff_salary_deductions'");
        $this->execute("ALTER TABLE `security_functions` COMMENT = 'This table contains the full list of features of the system'");
        $this->execute("ALTER TABLE `security_group_areas` COMMENT = 'This table contains which educational areas are accessible by which security group'");
        $this->execute("ALTER TABLE `security_group_institutions` COMMENT = 'This table contains specific institutions that can be accessible by which security group'");
        $this->execute("ALTER TABLE `security_group_users` COMMENT = 'This table contains the list of users assigned with a role in a security group'");
        $this->execute("ALTER TABLE `security_groups` COMMENT = 'This table contains the security groups used for allowing access for users to institutions'");
        $this->execute("ALTER TABLE `security_rest_sessions` COMMENT = 'Deprecated, used by older version of restful api'");
        $this->execute("ALTER TABLE `security_role_functions` COMMENT = 'This table contains the list of functions that can be accessed by the roles'");
        $this->execute("ALTER TABLE `security_roles` COMMENT = 'This table contains the list of roles that can be assigned to a user in a security group'");
        $this->execute("ALTER TABLE `security_user_logins` COMMENT = 'This table contains all user logins'");
        $this->execute("ALTER TABLE `security_user_sessions` COMMENT = 'This table contains the list of user sessions'");
        $this->execute("ALTER TABLE `security_users` COMMENT = 'This table contains all user information'");
        $this->execute("ALTER TABLE `shift_options` COMMENT = 'This table contains a fixed list of options for creating shifts in institutions'");
        $this->execute("ALTER TABLE `single_logout` COMMENT = 'This table contains the user login entries for single sign on'");
        $this->execute("ALTER TABLE `special_need_difficulties` COMMENT = 'This is a field option table containing the list of user-defined difficulties used by special needs'");
        $this->execute("ALTER TABLE `special_need_types` COMMENT = 'This is a field option table containing different types of special needs'");
        $this->execute("ALTER TABLE `staff_absence_reasons` COMMENT = 'This is a field option table containing different absence reasons for staff absences'");
        $this->execute("ALTER TABLE `staff_appraisal_types` COMMENT = 'This is a field option table containing the list of user-defined types of appraisal used by staff appraisals'");
        $this->execute("ALTER TABLE `staff_appraisals` COMMENT = 'This table contains all appraisals for a staff'");
        $this->execute("ALTER TABLE `staff_appraisals_competencies` COMMENT = 'This table contains the competency rating recorded of an appraisal for a staff'");
        $this->execute("ALTER TABLE `staff_behaviour_categories` COMMENT = 'This is a field option table containing the list of user-defined behaviour categories used by staff_behaviours'");
        $this->execute("ALTER TABLE `staff_behaviours` COMMENT = 'This table contains all behavioural records of staff'");
        $this->execute("ALTER TABLE `staff_change_types` COMMENT = 'This table contains a fixed list of change type for staff in institutions'");
        $this->execute("ALTER TABLE `staff_custom_field_options` COMMENT = 'This table contains the list of options used by custom field of type Dropdown'");
        $this->execute("ALTER TABLE `staff_custom_field_values` COMMENT = 'This table contains the value of user created custom fields for staff'");
        $this->execute("ALTER TABLE `staff_custom_fields` COMMENT = 'This table contains the list of user created custom fields for staff'");
        $this->execute("ALTER TABLE `staff_custom_forms` COMMENT = 'This table contains the labels to group the custom fields'");
        $this->execute("ALTER TABLE `staff_custom_forms_fields` COMMENT = 'This table indicates which custom fields is grouped under which form'");
        $this->execute("ALTER TABLE `staff_custom_table_cells` COMMENT = 'This table contains the values of a table-type question in a form'");
        $this->execute("ALTER TABLE `staff_custom_table_columns` COMMENT = 'This table contains the column name of a table-type question'");
        $this->execute("ALTER TABLE `staff_custom_table_rows` COMMENT = 'This table contains the row name of a table-type question'");
        $this->execute("ALTER TABLE `staff_employments` COMMENT = 'This table contains all other employment records of staff outside of OpenEMIS'");
        $this->execute("ALTER TABLE `staff_extracurriculars` COMMENT = 'This table contains extracurricular information of every staff'");
        $this->execute("ALTER TABLE `staff_leave_types` COMMENT = 'This is a field option table containing the list of user-defined types of leave used by institution_staff_leave'");
        $this->execute("ALTER TABLE `staff_licenses` COMMENT = 'This table contains the licenses information of every staff'");
        $this->execute("ALTER TABLE `staff_licenses_classifications` COMMENT = 'This table contains the list of licenses classifications linked to a particular staff license'");
        $this->execute("ALTER TABLE `staff_memberships` COMMENT = 'This table contains membership information of every staff'");
        $this->execute("ALTER TABLE `staff_position_grades` COMMENT = 'This is a field option table containing different position grades used in institution_positions'");
        $this->execute("ALTER TABLE `staff_position_titles` COMMENT = 'This is a field option table containing different position titles used in institution_positions'");
        $this->execute("ALTER TABLE `staff_qualifications` COMMENT = 'This table contains staff qualification information'");
        $this->execute("ALTER TABLE `staff_qualifications_subjects` COMMENT = 'This table contains the subjects that can be taught by teachers'");
        $this->execute("ALTER TABLE `staff_salaries` COMMENT = 'This table contains all salary information of staff'");
        $this->execute("ALTER TABLE `staff_salary_additions` COMMENT = 'This table contains any items with an amount to be added on top of the staff salary'");
        $this->execute("ALTER TABLE `staff_salary_deductions` COMMENT = 'This table contains any items with an amount to be deducted from the staff salary'");
        $this->execute("ALTER TABLE `staff_statuses` COMMENT = 'This table contains the fixed list of statuses for staff in institutions'");
        $this->execute("ALTER TABLE `staff_training_applications` COMMENT = 'This table contains the course applications for a particular staff'");
        $this->execute("ALTER TABLE `staff_training_categories` COMMENT = 'This is a field option table containing the list of user-defined categories used by training courses'");
        $this->execute("ALTER TABLE `staff_training_needs` COMMENT = 'This table contains the training needs of a staff'");
        $this->execute("ALTER TABLE `staff_training_self_studies` COMMENT = 'Not in used atm'");
        $this->execute("ALTER TABLE `staff_training_self_study_attachments` COMMENT = 'Not in used atm'");
        $this->execute("ALTER TABLE `staff_training_self_study_results` COMMENT = 'Not in used atm'");
        $this->execute("ALTER TABLE `staff_trainings` COMMENT = 'This table contains all training of staff'");
        $this->execute("ALTER TABLE `staff_types` COMMENT = 'This table contains the different types of a staff position'");
        $this->execute("ALTER TABLE `student_absence_reasons` COMMENT = 'This is a field option table containing different absence reasons for student absences'");
        $this->execute("ALTER TABLE `student_behaviour_categories` COMMENT = 'This is a field option table containing the list of user-defined behaviour categories used by student_behaviours'");
        $this->execute("ALTER TABLE `student_behaviours` COMMENT = 'This table contains all behavioural records of students'");
        $this->execute("ALTER TABLE `student_competency_results` COMMENT = 'This table contains all the competency results for an individual student in an institution'");
        $this->execute("ALTER TABLE `student_custom_field_options` COMMENT = 'This table contains the list of options used by custom field of type Dropdown'");
        $this->execute("ALTER TABLE `student_custom_field_values` COMMENT = 'This table contains the value of user created custom fields for student'");
        $this->execute("ALTER TABLE `student_custom_fields` COMMENT = 'This table contains the list of user created custom fields for student'");
        $this->execute("ALTER TABLE `student_custom_forms` COMMENT = 'This table contains the labels to group the custom fields'");
        $this->execute("ALTER TABLE `student_custom_forms_fields` COMMENT = 'This table indicates which custom fields is grouped under which form'");
        $this->execute("ALTER TABLE `student_custom_table_cells` COMMENT = 'This table contains the values of a table-type question in a form'");
        $this->execute("ALTER TABLE `student_custom_table_columns` COMMENT = 'This table contains the column name of a table-type question'");
        $this->execute("ALTER TABLE `student_custom_table_rows` COMMENT = 'This table contains the row name of a table-type question'");
        $this->execute("ALTER TABLE `student_extracurriculars` COMMENT = 'This table contains extracurricular information of students'");
        $this->execute("ALTER TABLE `student_fees` COMMENT = 'This table contains the list of payment transactions for individual student'");
        $this->execute("ALTER TABLE `student_guardians` COMMENT = 'This table contains all guardian records linked to individual student'");
        $this->execute("ALTER TABLE `student_indexes_criterias` COMMENT = 'This table contains the generated index of a criteria for a student'");
        $this->execute("ALTER TABLE `student_statuses` COMMENT = 'This table contains a fixed list of statuses for students in institutions'");
        $this->execute("ALTER TABLE `student_transfer_reasons` COMMENT = 'This is a field option table containing the list of user-defined transfer reasons used by student transfer'");
        $this->execute("ALTER TABLE `student_withdraw_reasons` COMMENT = 'This is a field option table containing the list of user-defined withdraw reasons used by student withdraw'");
        $this->execute("ALTER TABLE `survey_forms` COMMENT = 'This table contains all forms for data collection in institutions'");
        $this->execute("ALTER TABLE `survey_forms_questions` COMMENT = 'This table contains the list of questions in all forms'");
        $this->execute("ALTER TABLE `survey_question_choices` COMMENT = 'This table contains the choices for dropdown-type questions'");
        $this->execute("ALTER TABLE `survey_questions` COMMENT = 'This table contains the full list of questions'");
        $this->execute("ALTER TABLE `survey_responses` COMMENT = 'This table contains the XML data uploaded by users using OpenEMIS Survey on mobile'");
        $this->execute("ALTER TABLE `survey_rules` COMMENT = 'This table contains the rules for displaying survey questions'");
        $this->execute("ALTER TABLE `survey_status_periods` COMMENT = 'This table indicates the survey is done for which academic period'");
        $this->execute("ALTER TABLE `survey_statuses` COMMENT = 'This table indicates the date period that allows user for data entry'");
        $this->execute("ALTER TABLE `survey_table_columns` COMMENT = 'This table contains the column name of a table-type question'");
        $this->execute("ALTER TABLE `survey_table_rows` COMMENT = 'This table contains the row name of a table-type question'");
        $this->execute("ALTER TABLE `system_errors` COMMENT = 'This table contains the list of errors encountered by users'");
        $this->execute("ALTER TABLE `system_patches` COMMENT = 'Internal use - for tracking jira issues containing sql patches executed on this database'");
        $this->execute("ALTER TABLE `system_processes` COMMENT = 'Internal use - to track the background processes triggered by the system'");
        $this->execute("ALTER TABLE `system_updates` COMMENT = 'Internal use - to keep track of all stable versions of the system and their release date'");
        $this->execute("ALTER TABLE `textbook_conditions` COMMENT = 'This is a field option table containing the list of user-defined type of conditions used by institution textbooks'");
        $this->execute("ALTER TABLE `textbook_statuses` COMMENT = 'This table contains a fixed list of statuses for textbooks in institutions'");
        $this->execute("ALTER TABLE `textbooks` COMMENT = 'This table contains the textbooks of all subjects'");
        $this->execute("ALTER TABLE `training_achievement_types` COMMENT = 'Not in used atm'");
        $this->execute("ALTER TABLE `training_course_types` COMMENT = 'This is a field option table containing the list of user-defined type of courses used by training course'");
        $this->execute("ALTER TABLE `training_courses` COMMENT = 'This table contains all training courses'");
        $this->execute("ALTER TABLE `training_courses_prerequisites` COMMENT = 'This table contains all prerequisites related to specific training courses'");
        $this->execute("ALTER TABLE `training_courses_providers` COMMENT = 'This table contains the course providers for all training courses'");
        $this->execute("ALTER TABLE `training_courses_result_types` COMMENT = 'This table contains the result types linked to training courses'");
        $this->execute("ALTER TABLE `training_courses_specialisations` COMMENT = 'This table contains the specialisation of the training courses'");
        $this->execute("ALTER TABLE `training_courses_target_populations` COMMENT = 'This table contains the target staff positions who can apply for the training courses'");
        $this->execute("ALTER TABLE `training_field_of_studies` COMMENT = 'This is a field option table containing the list of user-defined field of studies used by training course'");
        $this->execute("ALTER TABLE `training_levels` COMMENT = 'This is a field option table containing the list of user-defined levels used by training course'");
        $this->execute("ALTER TABLE `training_mode_deliveries` COMMENT = 'This is a field option table containing the list of user-defined mode of delivery used by training course'");
        $this->execute("ALTER TABLE `training_need_categories` COMMENT = 'This is a field option table containing the list of user-defined categories used by staff training needs'");
        $this->execute("ALTER TABLE `training_priorities` COMMENT = 'This is a field option table containing the list of user-defined course priorities used by staff training needs'");
        $this->execute("ALTER TABLE `training_providers` COMMENT = 'This is a field option table containing the list of user-defined course provider used by training course'");
        $this->execute("ALTER TABLE `training_requirements` COMMENT = 'This is a field option table containing the list of user-defined course requirements used by training course'");
        $this->execute("ALTER TABLE `training_result_types` COMMENT = 'This is a field option table containing the list of user-defined types of results used by training course'");
        $this->execute("ALTER TABLE `training_session_results` COMMENT = 'This is a workflow table to group session results'");
        $this->execute("ALTER TABLE `training_session_trainee_results` COMMENT = 'This table contains the session results of every trainee of a training course'");
        $this->execute("ALTER TABLE `training_session_trainers` COMMENT = 'This table contains the list of trainers for specific training sessions'");
        $this->execute("ALTER TABLE `training_sessions` COMMENT = 'This table contains all training sessions'");
        $this->execute("ALTER TABLE `training_sessions_trainees` COMMENT = 'This table contains the list of trainees attending specific training sessions'");
        $this->execute("ALTER TABLE `training_specialisations` COMMENT = 'This is a field option table containing the list of user-defined specialisations used by training course'");
        $this->execute("ALTER TABLE `translations` COMMENT = 'This table contains all translations of text used in the system'");
        $this->execute("ALTER TABLE `user_activities` COMMENT = 'This table contains all modification of information of every user'");
        $this->execute("ALTER TABLE `user_attachments` COMMENT = 'This table contains file type information of every user'");
        $this->execute("ALTER TABLE `user_attachments_roles` COMMENT = 'This table contains the list of Attachments for specific Security Roles'");
        $this->execute("ALTER TABLE `user_awards` COMMENT = 'This table contains awards information of every user'");
        $this->execute("ALTER TABLE `user_bank_accounts` COMMENT = 'This table contains bank account information of every user'");
        $this->execute("ALTER TABLE `user_comments` COMMENT = 'This table contains comments of every user'");
        $this->execute("ALTER TABLE `user_contacts` COMMENT = 'This table contains contact information of every user'");
        $this->execute("ALTER TABLE `user_health_allergies` COMMENT = 'This table contains health allergy information of every user'");
        $this->execute("ALTER TABLE `user_health_consultations` COMMENT = 'This table contains health consultation information of every user'");
        $this->execute("ALTER TABLE `user_health_families` COMMENT = 'This table contains health families information of every user'");
        $this->execute("ALTER TABLE `user_health_histories` COMMENT = 'This table contains health histories information of every user'");
        $this->execute("ALTER TABLE `user_health_immunizations` COMMENT = 'This table contains health immunizations information of every user'");
        $this->execute("ALTER TABLE `user_health_medications` COMMENT = 'This table contains health medications information of every user'");
        $this->execute("ALTER TABLE `user_health_tests` COMMENT = 'This table contains health tests information of every user'");
        $this->execute("ALTER TABLE `user_healths` COMMENT = 'This table contains health information of every user'");
        $this->execute("ALTER TABLE `user_identities` COMMENT = 'This table contains identity information of every user'");
        $this->execute("ALTER TABLE `user_languages` COMMENT = 'This table contains all languages of every user that they know'");
        $this->execute("ALTER TABLE `user_nationalities` COMMENT = 'This table contains nationality information of every user'");
        $this->execute("ALTER TABLE `user_special_needs` COMMENT = 'This table contains special need information of every user'");
        $this->execute("ALTER TABLE `webhook_events` COMMENT = 'This table contains the list of webhook events'");
        $this->execute("ALTER TABLE `webhooks` COMMENT = 'This table contains the list of webhooks'");
        $this->execute("ALTER TABLE `workflow_actions` COMMENT = 'This table contains all actions used by different steps of any workflow'");
        $this->execute("ALTER TABLE `workflow_comments` COMMENT = 'This table contains comments added by users when performing a workflow action'");
        $this->execute("ALTER TABLE `workflow_models` COMMENT = 'This table contains the list of features that are workflow-enabled'");
        $this->execute("ALTER TABLE `workflow_rules` COMMENT = 'This table contains workflow rules associates with a specific workflow'");
        $this->execute("ALTER TABLE `workflow_statuses` COMMENT = 'This table contains the list of system-defined and user-defined statuses that are used by reports and other features'");
        $this->execute("ALTER TABLE `workflow_statuses_steps` COMMENT = 'This table contains the list of steps belonging to which status'");
        $this->execute("ALTER TABLE `workflow_steps` COMMENT = 'This table contains the list of steps used by all workflows'");
        $this->execute("ALTER TABLE `workflow_steps_roles` COMMENT = 'This table contains the list of steps accessible by which roles'");
        $this->execute("ALTER TABLE `workflow_transitions` COMMENT = 'This table contains specific action executed by users to transit from one step to another'");
        $this->execute("ALTER TABLE `workflows` COMMENT = 'This table contains all user defined workflows used by the system'");
        $this->execute("ALTER TABLE `workflows_filters` COMMENT = 'This table indicates the workflows triggered by the staff leave type'");
    }

    public function down()
    {

    }
}
